testjdbc.java

图书管理系统java+swing+SQL Server实现 包含了图书管理系统的所有功能 纯JAVA实现

package com.lishan;

import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.lishan.dao.Dao;

public class testjdbc {
	protected static String dbClassName = // 驱动包定义数据库连接驱动
	"com.microsoft.jdbc.sqlserver.SQLServerDriver";
	protected static String dbUrl = "jdbc:microsoft:sqlserver://localhost:1433;"
			+ "DatabaseName=db_library;SelectMethod=Cursor"; // 定义数据库连接路径
	protected static String dbUser = "sa"; // 定义数据库连接用户名
	protected static String dbPwd = "57lishan"; // 定义数据库连接密码
	protected static String second = null; // 确认密码
	protected static Connection conn = null; // 定义数据库连接

	private testjdbc() {
		/**
		 * 数据库连接步骤:1、装载驱动 2、获取连接
		 */
		try { // 捕捉数据库连接异常
			if (conn == null) { // 如果连接为空
				Class.forName(dbClassName).newInstance();// 装载SQL Server驱动
				conn = DriverManager.getConnection(dbUrl, dbUser, dbPwd);// 获取SQL
																			// Server数据库的连接
			} else
				return; // 如果连接不为空则，则返回此连接
		} catch (Exception ee) {
			ee.printStackTrace();
		}
	}

	private static ResultSet executeQuery(String sql) {// 执行查询语句的方法
		try {
			if (conn == null)
				new testjdbc(); // 如果数据库的连接为空，则创建连接
			// 返回一个可滚动，且受其他更新影响的，可更新结果集
			return conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
					ResultSet.CONCUR_UPDATABLE).executeQuery(sql);
		} catch (SQLException e) {
			e.printStackTrace();
			return null;
		} finally {

		}
	}

	private static int executeUpdate(String sql) { // 执行更新操作的方法
		try {
			if (conn == null)// 如果连接为空则创建连接,并生成一个状态对象,进行更新
				new testjdbc();
			return conn.createStatement().executeUpdate(sql);
		} catch (SQLException e) {
			System.out.println(e.getMessage());
			return -1;
		} finally {

		}
	}

	private static void close() { // 关闭数据库连接
		try {
			conn.close();
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			conn = null; // 在最终执行块中将数据库连接置空
		}
	}

	public int insertdata() {
		String sql = "insert into lee_operator values(1002,'江湖百晓生2','2',18,'350322123401011313',1903/06/29,'1234567','1','123456')";
		executeUpdate(sql);
		return 1;
	}

	public static int InsertReader(String name, String sex, String age,
			String identityCard, Date date, String maxNum, String tel,
			Double keepMoney, String zhengjian, String zhiye, Date bztime,
			String ISBN) {// 插入读者
		int i = 0;
		try {
			String sql = "update lee_reader set name='" + name + "',sex='"
					+ sex + "',age='" + age + "',identityCard='" + identityCard
					+ "',date='" + date + "',maxNum='" + maxNum + "',tel='"
					+ tel + "',keepMoney=" + keepMoney + ",zhengjianType='"
					+ zhengjian + "',zhiye='" + zhiye + "',banzhengtime='"
					+ bztime + "'where ISBN='" + ISBN + "'";
			i = testjdbc.executeUpdate(sql);
		} catch (Exception e) {
			e.printStackTrace();
		}
		testjdbc.close();
		return i;
	}

	public static int insertBook(String ISBN, String typeId, String bookName,
			String writer, String translator, String publisher, Date date,
			Double price) {
		int i = 0;
		try {
			String sql = "insert into lee_bookInfo(ISBN,typeId,bookname,writer,translator,publisher,date,price) values('"
					+ ISBN
					+ "','"
					+ typeId
					+ "','"
					+ bookName
					+ "','"
					+ writer
					+ "','"
					+ translator
					+ "','"
					+ publisher
					+ "','"
					+ date
					+ "'," + price + ")";
		} catch (Exception e) {
			System.out.println(e.getMessage());
		}
		testjdbc.close();
		return 1;
	}
	public static void main(String[] args) {
		testjdbc tj = new testjdbc();
		//tj.insertdata();
		Date d1 = new Date(10000000);
		Date d2 = new Date(10023435);
		int i = tj.insertBook("LSDBRJGC10001", "10", "Think in JAVA", "Bruce Eckel", "陈昊鹏", "**信息出版社", d1, 108.0);
		System.out.println(i);
	}

}