• 连接mysql数据库执行写入语句


    package insert;
    
    import java.sql.DriverManager;
    import java.sql.SQLException;
     
    import com.mysql.jdbc.Connection;
     
    public class DButil {
    		/*
    		 * 打开数据库
    		 */
    	    private static String driver;//连接数据库的驱动
    	    private static String url;
    	    private static String username;
    	    private static String password;
    	    
    	    static {
    	    	driver="com.mysql.jdbc.Driver";//需要的数据库驱动
    	    	url="jdbc:mysql://localhost:3306/test?serverTimezone=GMT%2B8&useSSL=false";//数据库名路径
    	    	username="root";
    	    	password="xxxx";
    	    }
    		public static Connection open()
    		{
    			try {
    				Class.forName(driver);
    				return (Connection) DriverManager.getConnection(url,username, password);
    			} catch (Exception e) {
    				System.out.println("数据库连接失败!");
    				// TODO Auto-generated catch block
    				e.printStackTrace();
    			}//加载驱动
     
    			return null;
    		}
            
    		/*
    		 * 关闭数据库
    		 */
    		public static void close(Connection conn)
    		{
    			if(conn!=null)
    			{
    				try {
    					conn.close();
    				} catch (SQLException e) {
    					// TODO Auto-generated catch block
    					e.printStackTrace();
    				}
    			}
    		}
     
    }
    

      需要引入   mysql-connector-java-5.1.45-bin.jar

    执行类

    package insert;
    
    import java.sql.SQLException;
    
    import com.mysql.jdbc.Connection;
    import com.mysql.jdbc.PreparedStatement;
     
    public class jdbcconnection {
     
    	public static void main(String[] args) {
    		// TODO Auto-generated method stub
           insert("yangxu",1,"beijing","15022009896",false);
    	}
     
    	static void insert(String name,int age,String address,String phone,boolean flag)
    	{
    		String sql="insert into student(name,age,address,phone,flag) value(?,?,?,?,?)";
    		Connection conn=DButil.open();
    		try {
    			PreparedStatement pstmt=(PreparedStatement) conn.prepareStatement(sql);
    			pstmt.setString(1,name);
    			pstmt.setInt(2,age);
    			pstmt.setString(3,address);
    			pstmt.setString(4,phone);
    			pstmt.setBoolean(5, flag);
    			pstmt.executeUpdate();
    		} catch (SQLException e) {
    			// TODO Auto-generated catch block
    			e.printStackTrace();
    		}
    		finally {
    			DButil.close(conn);
    		}
    		
    	}
    }
    

      //实体类

    package insert;
    
    public class Customer {
    	
    	 String name;
    	 int age;
    	 String address;
    	 String phone;
    	 boolean flag;
    	public String getName() {
    		return name;
    	}
    	public void setName(String name) {
    		this.name = name;
    	}
    	public int getAge() {
    		return age;
    	}
    	public void setAge(int age) {
    		this.age = age;
    	}
    	public String getAddress() {
    		return address;
    	}
    	public void setAddress(String address) {
    		this.address = address;
    	}
    	public String getPhone() {
    		return phone;
    	}
    	public void setPhone(String phone) {
    		this.phone = phone;
    	}
    	public boolean isFlag() {
    		return flag;
    	}
    	public void setFlag(boolean flag) {
    		this.flag = flag;
    	}
    	@Override
    	public String toString() {
    		return "Customer [name=" + name + ", age=" + age + ", address=" + address + ", phone=" + phone + ", flag="
    				+ flag + "]";
    	}
    	 
    	
    }
    

      

  • 相关阅读:
    Android Loader异步装载
    Android 清除本地缓存
    Android 小知识
    Android 百度地图用法
    ANDROID笔记:四大组件之广播
    Android扩展:一个自动findViewById的小工具
    ANDROID笔记:基于handle的异步请求网络数据的一种方法
    ANDROID笔记:多线程断点下载
    ANDROID笔记:AIDL介绍
    ANDROID笔记:activity通过ContentProvider传值(仿调用系统图片浏览器过程)
  • 原文地址:https://www.cnblogs.com/xianz666/p/15340493.html
Copyright © 2020-2023  润新知