src/com/dao/DB.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DB
{
	private Connection con;

	private PreparedStatement pstm;

//	private String user = "sa";
//
//	private String password = "welcome";
//
//	private String className = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
//
//	private String url = "jdbc:sqlserver://localhost:1433;databaseName=db_book";
	
	private String user = "root";

	private String password = "root";

	private String className = "com.mysql.jdbc.Driver";

	private String url = "jdbc:mysql://localhost:3306/db_jspgita?characterEncoding=utf8";

    private Connection conn=null;
    private Statement stmt=null;
    ResultSet rs=null;
    
    public DB()
	{
		try
		{
			Class.forName(className);
		} catch (ClassNotFoundException e)
		{
			System.out.println("失败");
			e.printStackTrace();
		}
	}

	/** ????????l?? */
	public Connection getCon()
	{
		try
		{
			con = DriverManager.getConnection(url, user, password);
		} catch (SQLException e)
		{
			System.out.println("失败");
			con = null;
			e.printStackTrace();
		}
		return con;