java ee导入mysql 连接_JAVA EE 连接MySql数据库

Stringpath=request.getContextPath();StringbasePath=request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%>

">

My JSP ‘index.jsp‘ starting page

//声明Connection对象

Connection con;//驱动程序名Stringdriver= "com.mysql.jdbc.Driver";//URL指向要访问的数据库名mydataStringurl= "jdbc:mysql://localhost:3306/USERINFO";//MySQL配置时的用户名Stringuser= "root";//MySQL配置时的密码Stringpassword= "699307";//遍历查询结果集

Connection conn= null;

try {//加载驱动程序

Class.forName(driver);//1.getConnection()方法，连接MySQL数据库！！

conn=DriverManager.getConnection(url,user,password);if(!conn.isClosed())

System.out.println("Succeeded connecting to the Database!");//2.创建statement类对象，用来执行SQL语句！！

Statement st=conn.createStatement();//执行sql语句Stringsql= "select * from USERINFO";//增删改查表中的内容，用executeUpdate方法

st.executeUpdate("insert into USERINFO(USERID, USERNAME) values (1, ‘NOSTRING‘)");

st.executeUpdate("insert into USERINFO(USERID, USERNAME) values (2, ‘BECHAR‘)");

st.executeUpdate("insert into USERINFO(USERID, USERNAME) values (3, ‘ALEXVIEW‘)");//读取表的内容，用executeQuery方法

ResultSet rs=st.executeQuery("select * from USERINFO");//循环输出内容while(rs.next()){intuserID=rs.getInt(1);Stringusername=rs.getString(2);

out.println("-------------------
");

out.println("uerid:"+userID+"
");

out.println("username:"+username+"
");

out.println("-------------------
");

}

}catch(SQLException e){

out.print(e.getErrorCode()+ "
");

out.print(e.getCause()+ "
");

out.print(e.getMessage()+ "
");if(conn != null)

conn.close();

}%>