try
{
int req_id=Integer.parseInt(request.getParameter("id"));
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:amcdb","","");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select email from detail where id="+req_id+"");
String result;
String to=rs.getString(4);
}
Pavithra_1
0
Newbie Poster
Recommended Answers
Jump to PostAssign the result of a query to a string using 'next()' with 'while' looping
while (rs.next()) { result = rs.getString(1); }
All 3 Replies
pyaythu
0
Newbie Poster
JamesCherrill
4,733
Most Valuable Poster
Team Colleague
Featured Poster
jwenting
1,889
duckman
Team Colleague
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.