dataconnect.java

来自「JAVA网上书店的程序原代码,希望对大家偶用」· Java 代码 · 共 69 行

package ebookshop.common;

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

public class DataConnect
{
	public DataConnect()
	{}
	
	public static Connection getConnection(String dbName)
	{
		Connection con=null;		
		try {
			Class.forName("org.gjt.mm.mysql.Driver");
				
		} catch (ClassNotFoundException e) {
				
			e.printStackTrace();
				//return;
		}
			
		try {
			con = DriverManager.getConnection("jdbc:mysql://localhost:3306/" +
							 dbName+"?useUnicode=true&characterEncoding=gb2312","root","abing");
		}
			catch (SQLException e) {
				
				e.printStackTrace();
			}
		return con;
		
	}
	
	public static void main(String[] args)
	{
		DataConnect dbc=new DataConnect();
		Connection con=dbc.getConnection("netbookdata");
		Statement st =null;
		ResultSet rs =null;
		try
		{
			
			st=con.createStatement();
			rs=st.executeQuery("select userName,passWord from customer;");
			
				while(rs.next())
				{
					System.out.println(rs.getString("userName"));
					System.out.println(rs.getString("passWord"));
				}
				
				rs.close();
				st.close();
				con.close();
			
		}
		catch(Exception e)
		{
			e.getStackTrace();
		}
		
		
	}
}