java连接sql数据库代码

来源：互联网发布：淘宝团购在哪里编辑：程序博客网时间：2024/05/17 10:27

import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class BaseDAO {private static String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";private static String url="jdbc:sqlserver://localhost:1433;DatabaseName=zjlMovie";private static String userName="sa";private static String password="123456";protected static Connection con=null;protected PreparedStatement pstm=null;protected ResultSet rs=null;public void getConnection(){try {Class.forName(driverName);con=DriverManager.getConnection(url, userName, password);} catch (ClassNotFoundException e) {e.printStackTrace();} catch (SQLException e) {e.printStackTrace();}}public void closeAll(){try {if(rs!=null){rs.close();}if(pstm!=null){pstm.close();}if(con!=null){con.close();}} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}

0 0