java、jsp连接数据库，可当模板

来源：互联网发布：数据分析的基本流程编辑：程序博客网时间：2024/06/08 11:48

新建一个MyJdbc的class：

package cn.itcast.jdbc;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import com.mysql.jdbc.Statement;public class Jdbc {public static void main(String[] args) throws Exception{template();}static void template() throws Exception{String url = "jdbc:mysql://localhost:3306/jdbc";String user = "root";String password = "123";Connection conn = null;Statement st = null;ResultSet rs = null;try {//注册驱动Class.forName("com.mysql.jdbc.Driver");//建立连接conn = DriverManager.getConnection(url, user, password);//创建语句,装载数据的车st = (Statement) conn.createStatement();//执行语句，sql语句rs = st.executeQuery("select * from user");//处理结果while(rs.next()){System.out.println(rs.getObject(1) + "\t" + rs.getObject(2)+ "\t" + rs.getObject(3) + "\t" + rs.getObject(4));}} finally {try{                                             //关闭通道if(rs != null)rs.close();}finally{try{if(st != null)st.close();}finally{if(conn != null)conn.close();}}}}}

0 0