准备工作:
1,在MySQL中创建学生表student
2,在java项目里创建lib,将jar包拷入并且Add to build path
3. 创建接口
package jdbc;
import java.sql.ResultSet;
public interface IRowMapper {
void rowMapper(ResultSet rs);
}
3,创建工具类
package jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/**
*
*
*
* @author ChenLingFeng
*/
public class DBLink {
/**
* 获取数据库连接 *
*
* @author Lenovo
*/
private Connection getConnection() {
try {
Class.forName("com.mysql.jdbc.Driver"); //加载驱动
String url= "jdbc:mysql://127.0.0.1:3306/test";
return DriverManager.getConnection(url, "root", "root"); //建立连接
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return null;
}
/**
* 对数据进行添加,删除,修改等操作
*
*
* @author Lenovo
*/
public boolean update(String sql,Object ...params) {
Connection connection=null;
PreparedStatement preparedStatement=null;
try {
connection=getConnection();
preparedStatement=connection.prepareStatement(sql);
for (int i = 0; i < params.length; i++) {
preparedStatement.setObject(i+1, params[i]);
}
return preparedStatement.executeUpdate()>0;
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally {
cl