2024年3月25日发(作者：)

常用数据库连接语句

一：Mysql的数据库连接语句

e("");

Connection con =

nection.("jdbc:mysql://localhost:3306/bookinfo","root","123

");

Statement st = Statement();

String sql = "select * from book";

ResultSet rs = eQuery(sql);

while(()){

}

二：sqlserver的数据库连接语句

e("verDriver");

Connection con =

nection.("jdbc:microsoft:sqlserver://localhost:1433;databas

eName=bookinfo","sa","123");

PreparedStatement ps = eStatement("select * from book");

ResultSet rs = eQuery();

while(()){

n(ing(2));

}

三：sqlserver2005的数据库连接语句

e("verDriver");

Connection con =

nection.("jdbc:sqlserver://localhost:1433;databaseName=b

ookinfo","sa","123");

PreparedStatement ps = eStatement("select * from book");

ResultSet rs = eQuery();

while(()){