package t;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBCTest {
public static void main(String[] args) {
// TODO Auto-generated method stub
//mySql连接java
Driver driver=null;
try {
driver = new com.mysql.cj.jdbc.Driver();//加载驱动
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
DriverManager.deregisterDriver(driver);//驱动注册
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
Connection connection=null;
try {
connection=DriverManager.getConnection("jdbc:mysql://localhost:3306/employee?characterEncoding=utf8&useSSL=false&serverTimezone=UTC&rewriteBatchedStatements=true&allowPublicKeyRetrieval=true", "root", "password");//获得连接
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
PreparedStatement statement=null;
String sql="select * from course where cno= ? ";//编写sql
try {
statement=connection.prepareStatement(sql);//获得praparestatement对象并注入sql
statement.setString(1,"3-105");//参数绑定
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
ResultSet resultSet=null;
try {
resultSet=statement.executeQuery();//获得结果集
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
while(resultSet.next()) {
System.out.println(resultSet.getString(1));//结果集解析
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
statement.close();//关闭statement对象
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}//
try {
connection.close();//关闭连接
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
prepareStatement防sql注入的使用
最新推荐文章于 2023-06-07 20:29:27 发布