依赖 Mysql mysql-connector-java 5.1.27 代码实现 import java.sq
Mysql
mysql-connector-java
5.1.27
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class JDBCTest {
public static void main(String[] args) throws Exception {
//1.加载驱动
Class.forName("com.mysql.jdbc.Driver");
//2.获取与数据库的链接
String url = "jdbc:mysql://localhost:3306/test";
String username = "root";
String passWord = "root";
Connection conn = null;
conn = DriverManager.getConnection(url, username, password);
//3.获取用于向数据库发送sql语句的Preperedstatement
PreparedStatement st = null;
String sql = "select * from users where name=? and password=?";
st = conn.prepareStatement(sql);//在此次传入,进行预编译
st.setString(1, username);
st.setString(2, password);
//4.向数据库发sql,并获取代表结果集的resultset
ResultSet rs = null;
rs = st.executeQuery(sql);
//5.取出结果集的数据
//循环取出(id)
while (rs.next()) {
String id = rs.getString(1);//1代表数据库中表的列数,id在第一列也可以("id")!!!
System.out.println(id + " ");
}
//6.关闭链接,释放资源
if (rs != null) {
try {
rs.close();
} catch (Exception e) {
e.printStackTrace();
}
rs = null;
}
if (st != null) {
try {
st.close();
} catch (Exception e) {
e.printStackTrace();
}
}
if (conn != null) {
try {
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
}
JDBC连接MySQL
--结束END--
本文标题: JDBC连接MySQL
本文链接: https://www.lsjlt.com/news/7899.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
2024-05-03
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0