JSP Page
Hello World!
String CLASS_NAME="com.mysql.jdbc.Driver";
String url="jdbc:mysql://localhost:3306/mydb?zeroDateTimeBehavior=convertToNull";
String user="root";
String password="123456";
Connection conn=null;
PreparedStatement pstm=null;
ResultSet rs=null;
try{
Class.forName(CLASS_NAME);
}
catch(ClassNotFoundException e){
e.printStackTrace();
}
try{
conn=DriverManager.getConnection(url, user, password);
pstm = conn.prepareStatement("select * from Doctor");
rs=pstm.executeQuery();
while(rs.next()){
System.out.print(rs.getString("DocName"));
}
}catch(SQLException e){
e.printStackTrace();
}
%>
展开