java连接数据库代码
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
public class sql {
public static void main(String[] args) {
String user = "user";
String password = "123456";
Connection conn;
Statement stmt;
ResultSet rs;
String url = "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=LBMS;";
String sql = "select * from book_inf";
try {
conn = DriverManager.getConnection(url, user, password);
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
while (rs.next()) {
String name = rs.getString("book_name");
String id = rs.getString("book_id");
float styleno = rs.getFloat("book_styleno");
String price = rs.getString("book_price");
System.out.println(" 书籍编号 "+id+" 书名 "+name+" 书籍种类 "+styleno+" 书籍价格 "+price);
}
if (rs != null) {
rs.close();
rs = null;
}
if (stmt != null) {
stmt.close();
stmt = null;
}
if (conn != null) {
conn.close();
conn = null;
}
} catch (SQLException e) {
e.printStackTrace();
System.out.println("数据库连接失败");
}
}
}