mysql数据库连接

标题 mysql数据库连接

import java.sql.*;
public class data {
    Connection con;
    ResultSet res;
    PreparedStatement sql;
    public data(){
        try {
            //加载驱动
            Class.forName("com.mysql.jdbc.Driver");
            System.out.println("数据库驱动加载成功");
            //连接数据库
            con=DriverManager.getConnection("jdbc:mysql://localhost:3306/mybase","用户名","密码");
            System.out.println("数据库连接成功");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
    }
    /*数据库操作*/
    //插入语句
    public void insert(String user,String password) {
        try {
        	//预处理语句
            this.sql = this.con.prepareStatement("insert into user value(?,?)");
            this.sql.setString(1,user);
            this.sql.setString(2,password);
            this.sql.executeUpdate();
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }

    }
    //查询语句
    public String select(String user){
        String password=null;
        try {
            this.sql = this.con.prepareStatement("select password from user where username=?");
            this.sql.setString(1,user);
            sql.setString(1,user);
            res=sql.executeQuery();
            //从预处理的地方查找，查到则返回，否则返回null
            while (res.next()){
                password=res.getString("password");
                return password;
            }

        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }
        return null;
    }
    
    public static void main(String[] args) {
        data data = new data();
        String z=data.select("003");
        System.out.println(z);
    }
    
}