java代码练习 work153

work153.java

package test08;

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


public class work153
{
	static Connection con1;
	static PreparedStatement sql1;
	static ResultSet res1;
	
	public Connection getConnection()
	{
		try
		{
			Class.forName("com.mysql.jdbc.Driver");
			con1 = DriverManager.getConnection("jdbc:mysql://127.0.0.1/test","root","mysql123");
			
		} catch (Exception e)
		{
			e.printStackTrace();
		}
		return con1;
	}

	public static void main(String[] args)
	{
		work153 s1 = new work153();
		work153.con1 = s1.getConnection();
		
		try
		{
			sql1 = con1.prepareStatement("select * from user where user_id = ?");
			sql1.setInt(1, 2);
			res1 = sql1.executeQuery();
			while (res1.next())
			{
				String id = res1.getString(1);
				String name = res1.getString("user_name");
				System.out.println(id + " " + name);
			}
		} catch (Exception e)
		{
			e.printStackTrace();
		}

	}

}