import java.sql.*;
public class connect {
public static void main(String[] args)
{
try
{
Connection conn;
Statement stmt;
ResultSet res;
//加载Connector/J驱动
//这一句也可写为:Class.forName("com.mysql.jdbc.Driver");
Class.forName("com.mysql.jdbc.Driver").newInstance();
//建立到MySQL的连接
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/chenluancl?useUnicode=true&characterEncoding=GBK",
"root", "123456");
//执行SQL语句
//stmt=conn.prepareStatement("INSERT INTO `chenluancl`.`student` (`id` ,`name` ,`address`)VALUES ('68', '陈銮12323423', '大');");
stmt=conn.createStatement();
// stmt.execute("INSERT INTO `chenluancl`.`student` (`id` ,`name` ,`address`)VALUES ('68', '陈銮12323423', '大12312412414');");
res=stmt.executeQuery("Select * from student");
//处理结果集
while (res.next())
{
String name = res.getString("name");
System.out.println(name);
}
conn.close();
}
catch (Exception ex)
{
System.out.println("Error : " + ex.toString());
}
}
}
JAVA 连MYSQL
最新推荐文章于 2023-06-15 21:49:16 发布