jdbc的编程步骤

1.加载驱动程序
Class.forName(driverclass)
MySQL驱动:Class.forName(“com.mysql.jdbc.Driver”);
Oracle驱动:Class.forName(“oracle.jdbc.driver.OracleDriver”)
2.获取数据库连接
Connection conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/imooc","root","root");
3.创建Statement对象操作数据库

第一种方式:无占位符形式

Statement stmt=conn.createStatement();
String sql="select * from godness_info";
ResultSet rs=stat.executeQuery(sql);
List<Godness> list=new ArrayList<Godness>();
Godness godness=null;
while(rs.next()){
godness=new Godness();
godness.setUser_name(rs.getString("user_name"));
godness.setSex(rs.getInt("sex"));
godness.setAge(rs.getInt("age"));
godness.setBirthday(rs.getDate("birthday"));
godness.setEmail(rs.getString("email"));
godness.setMobile(rs.getString("mobile"));
godness.setCreate_user(rs.getString("create_user"));
godness.setCreate_date(rs.getDate("create_date"));
godness.setUpdate_user(rs.getString("update_user"));
godness.setUpdate_date(rs.getDate("update_date"));
odness.setIsdel(rs.getInt("isdel"));
list.add(godness);
}
第二种方式:有占位符形式,占位符下标从1开始
String sql="insert into godness_info"+
"(user_name,sex,age,birthday,email,mobile,"+
"create_user,create_date,update_user,update_date,isdel)"+
"values("+
"?,?,?,?,?,?,?,current_date(),?,current_date(),?)";
PreparedStatement ps=conn.prepareStatement(sql);
ps.setString(1, g.getUser_name());
ps.setInt(2, g.getSex());
ps.setInt(3, g.getAge());
ps.setDate(4, new Date(g.getBirthday().getTime()));
ps.setString(5, g.getEmail());
ps.setString(6, g.getMobile());
ps.setString(7, g.getCreate_user());
ps.setString(8, g.getUpdate_user());
ps.setInt(9, g.getIsdel());
ps.execute();