/**
*
*/
package com.dao;
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.Enumeration;
import java.util.List;
import javax.swing.AbstractButton;
import com.model.Admin;
import com.model.Book;
import com.model.BookType;
import com.model.Return;
import com.model.user;
/**
* @author Administrator
*
*/
public class Dao {
static String dbClassName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
static String dbUrl = "jdbc:microsoft:sqlserver://localhost:1433;"
+ "DatabaseName=library;SelectMethod=Cursor";
static String dbUser = "sa";
static String dbPwd = "";
static String second = null;
static Connection conn = null;
//加载驱动 连接到数据库
Dao() {
try {
if (conn == null) {
Class.forName(dbClassName).newInstance();
conn = DriverManager.getConnection(dbUrl, dbUser, dbPwd);
System.out.println("ok!");
}
else
return;
} catch (Exception ee) {
ee.printStackTrace();
System.out.println("Errot!");
}
}
//执行查询操作
static ResultSet executeQuery(String sql) {
try {
if(conn==null)
new Dao();
return conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE).executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
System.out.println("查询异常!");
return null;
} finally {
}
}
//执行更新操作
static int executeUpdate(String sql) {
try {
if(conn==null)
new Dao();
return conn.createStatement().executeUpdate(sql);
} catch (SQLException e) {
System.out.println(e.getMessage());
//if(e.getMessage().equals("[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]DELETE 语句与 COLUMN REFERENCE 约束 'FK_TB_BORRO_REFERENCE_TB_BOOKI' 冲突。该冲突发生于数据库 'db_library',表 'tb_borrow', column 'bookISBN'。"))
return -1;
} finally {
}
}
//关闭查询
public static void close() {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}finally{
conn = null;
}
}
*
*/
package com.dao;
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.Enumeration;
import java.util.List;
import javax.swing.AbstractButton;
import com.model.Admin;
import com.model.Book;
import com.model.BookType;
import com.model.Return;
import com.model.user;
/**
* @author Administrator
*
*/
public class Dao {
static String dbClassName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
static String dbUrl = "jdbc:microsoft:sqlserver://localhost:1433;"
+ "DatabaseName=library;SelectMethod=Cursor";
static String dbUser = "sa";
static String dbPwd = "";
static String second = null;
static Connection conn = null;
//加载驱动 连接到数据库
Dao() {
try {
if (conn == null) {
Class.forName(dbClassName).newInstance();
conn = DriverManager.getConnection(dbUrl, dbUser, dbPwd);
System.out.println("ok!");
}
else
return;
} catch (Exception ee) {
ee.printStackTrace();
System.out.println("Errot!");
}
}
//执行查询操作
static ResultSet executeQuery(String sql) {
try {
if(conn==null)
new Dao();
return conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE).executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
System.out.println("查询异常!");
return null;
} finally {
}
}
//执行更新操作
static int executeUpdate(String sql) {
try {
if(conn==null)
new Dao();
return conn.createStatement().executeUpdate(sql);
} catch (SQLException e) {
System.out.println(e.getMessage());
//if(e.getMessage().equals("[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]DELETE 语句与 COLUMN REFERENCE 约束 'FK_TB_BORRO_REFERENCE_TB_BOOKI' 冲突。该冲突发生于数据库 'db_library',表 'tb_borrow', column 'bookISBN'。"))
return -1;
} finally {
}
}
//关闭查询
public static void close() {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}finally{
conn = null;
}
}
驱动程序名String driver = "com.mysql.jdbc.Driver";// URL指向要访问的数据库名scutcsString url = "jdbc:mysql://127.0.0.1:3306/scutcs";// MySQL配置时的用户名String user = "root";// Java连接MySQL配置时的密码String password = "root";try {// 加载驱动程序Class.forName(driver);// 连续数据库Connection conn = DriverManager.getConnection(url, user, password);if(!conn.isClosed())System.out.println("Succeeded connecting to the Database!");// statement用来执行SQL语句Statement statement = conn.createStatement();// 要执行的SQL语句String sql = "select * from student";结果集
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Timestamp;
import java.util.ArrayList;
import java.util.Enumeration;
import java.util.List;
import javax.swing.AbstractButton;
import com.model.Admin;
import com.model.Book;
import com.model.BookType;
import com.model.Return;
import com.model.user;
/**
* @author Administrator
*
*/
public class Dao {
static String dbClassName = "com.mysql.jdbc.Driver"; //mysql的驱动
static String dbUrl = "jdbc:mysql://localhost:3306/library"; //连接url地址
static String dbUser = "root"; //mysql的用户名字
static String dbPwd = ""; //对应的密码,如果你设定了,就该成你设定的密码
static Connection conn = null;
//加载驱动 连接到数据库
Dao() {
try {
if (conn == null) {
Class.forName(dbClassName);
conn = DriverManager.getConnection(dbUrl, dbUser, dbPwd);
System.out.println("ok!");
}
else
return;
} catch (Exception ee) {
ee.printStackTrace();
System.out.println("Errot!");
}
}
//执行查询操作
static ResultSet executeQuery(String sql) {
try {
if(conn==null)
new Dao();
return conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE).executeQuery(sql);
} catch (SQLException e) {
e.printStackTrace();
System.out.println("查询异常!");
return null;
} finally {
}
}
//执行更新操作
static int executeUpdate(String sql) {
try {
if(conn==null)
new Dao();
return conn.createStatement().executeUpdate(sql);
} catch (SQLException e) {
System.out.println(e.getMessage());
//if(e.getMessage().equals("[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]DELETE 语句与 COLUMN REFERENCE 约束 'FK_TB_BORRO_REFERENCE_TB_BOOKI' 冲突。该冲突发生于数据库 'db_library',表 'tb_borrow', column 'bookISBN'。"))
return -1;
} finally {
}
}
//关闭查询
public static void close() {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}finally{
conn = null;
}
}