JSP连接MySQL数据库

[黄海深]

没装MySQL。

[liuyuhua0066]

连别人的Mysql？

[niuniu20008]

package com.asia.jdbc;

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

public class MySqlJdBc {

	public static void main(String[] args) {
		Connection con = null;
		PreparedStatement pstm = null;
		
		try {
			Class.forName("org.gjt.mm.mysql.Driver");
			con = DriverManager.getConnection("jdbc:mysql://localhost:3306/tesql", "root", "");
			String sql = "select username ,email from user";
			pstm = con.prepareStatement(sql);
			pstm.executeQuery();
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
				try {
					if(pstm!=null)
					pstm.close();
					if(con!=null)
						con.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
		}
	}
}

[liuyuhua0066]

org.gjt.mm.mysql.Driver
这个Driver有点年头了。估计好多都不支持了。
[Quote=引用 2 楼 niuniu20008 的回复:]
Java code


package com.asia.jdbc;

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

public class MySqlJdBc {

……
[/Quote]

[benac]

package com.study.db.utils;

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

public class DBConn {
	
	private static String url = "jdbc:mysql://localhost:3306/test";
	private static String user = "root";
	private static String password = "123";

	public Connection con=null;
	public Statement stmt=null;
	public ResultSet rs=null;
	
	public DBConn() {
		try {
			Class.forName("com.mysql.jdbc.Driver").newInstance();
		} catch (InstantiationException e) {
			System.out.println(e.getMessage());
			e.printStackTrace();
		} catch (IllegalAccessException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
	
	public Connection getConn(String url,String username,String password){
		try {
			con= DriverManager.getConnection(url,username,password);
		} catch (SQLException e) {
			System.out.println("数据库连接失败 "+e.getMessage());
		}
		return con;
	}
	
	public Connection getConn(){
		try {
			con= DriverManager.getConnection(url,user,password);
		} catch (SQLException e) {
			System.out.println("数据库连接失败 "+e.getMessage());
		}
		return con;
	}
	
	public static void free(ResultSet rs, Statement st, Connection conn) {
		try {
			if (rs != null)
				rs.close();
		} catch (SQLException e) {
		} finally {
			try {
				if (st != null)
					st.close();
			} catch (SQLException e) {
				e.printStackTrace();
			} finally {
				try {
					if (conn != null)
						conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			}
		}
	}
	
	public void showUser(){
		
	}
	
	
	public static void main(String[] args) {
		DBConn dbcon=new DBConn();
		try {
			dbcon.getConn().createStatement();
			String sql="select * from user";
			rs=stmt.executeQuery(sql);
			while (rs.next()) {
				rs.getInt(1);
				rs.getString("name");
				rs.getString("sex");
				System.out.println(rs.getObject(1) + "\t" + rs.getObject(2)+"\t" + rs.getObject(3));
			}
		} catch (SQLException e) {
			System.out.println("建立sql语句失败 "+e.getMessage());
			e.printStackTrace();
		}finally{
			free(rs,stmt,con);
		}
		

	}

}

[QQ644486560]

[Quote=引用 4 楼 benac 的回复:]

Java code
package com.study.db.utils;

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

public class DB……
[/Quote]

+1

[我是小飞]

jdbc

[xue785920414]

干嘛不装MySql啊，要脸别人的MySql很麻烦的，再说，MySql安装比较简单，也很小

[xue785920414]

干嘛不装MySql啊，要连别人的MySql很麻烦的，再说，MySql安装比较简单，也很小