试了一下jdbc书写
先加载jar包 然后
jdbcutil:记载驱动,获得连接
public class JdbcUtils {
public static Connection getConnection() throws Exception{
Connection connection=null;
//加载对应驱动
try{
Class.forName("com.mysql.jdbc.Driver");
connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/user", "root", "root");
}
catch(Exception e){
e.printStackTrace();
}
return connection;
}
}
updata:有个巨坑的点,use表要加上如图那个,然后那个是波浪线上面的那个点,把我搞蒙死了
public String update(User user) {
Connection connection= null;
Statement statement=null;
try {
connection=JdbcUtils.getConnection();
String sql="update `use` set username='cai123' where id=3";
statement=connection.createStatement();
// connection.prepareStatement(sql,)
statement.executeUpdate(sql);
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
别的就不展示了,巨坑点 记住